Table Maintenance Tasks

Select the table for maintaining in the object pane. Control-click and select the Maintain from the popup menu.

Enable / Disable Table Lock
Allows / Prevents DDL operations on the table.

Enable / Disable Row Movement
Allows / Prevents the database to move a row.

Shrink Space
Shrinks space in a table.

Move
Relocates data of a nonpartitioned table or of a partition of a partitioned table into a new segment.

Validate Table Structure
Verifies the integrity of the structure of a table.

Collect Table Statistics
Collects table statistics.